MySQL Maintenance Tasks

Navicat provides a complete solution for most of the native MySQL services, which are intended for database and table maintenance. To make your work with the server easier, Navicat also provides some graphical tools for working with the server as a whole.

Analyze Table
Analyzes and stores the key distribution for the table.

Check Table
Checks the database tables for errors.

Optimize Table
Reclaims the unused space in tables and defragments the data files.

Repair Table
Repairs database tables that are corrupted.

Flush
Clears the internal MySQL caches.